select
	non empty(
		[Date].[Calendar Year].&[2006] : 
		[Date].[Calendar Year].&[2008]  *
		[Date].[Calendar Semester of Year].[Calendar Semester of Year] *
		[Date].[Calendar Quarter of Year].[Calendar Quarter of Year]
	) on columns,
	non empty(
		[Product].[Category].[Category] *
		[Sales Reason].[Sales Reason Type].[Sales Reason Type]
	) on rows,
	{[Sales Channel].[Sales Channel].[Sales Channel]} on pages,
	{
		[Sales Territory].[Sales Territory].[Group].&[Europe], 
		[Sales Territory].[Sales Territory].[Group].&[North America]
	} on sections
from [Adventure Works]
where [Measures].[Average Sales Amount]